CREATE TABLE [dbo].[TTCANC_FINA]
(
[CO_EMPR] [dbo].[TD_VC_002] NOT NULL,
[CO_BANC] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CO_TIPO_FINA] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[NU_COMP_CANC] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TI_DOCU_BANC] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[NU_DOCU_BANC] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FE_OPER] [datetime] NULL,
[FA_TIPO_CAMB] [numeric] (15, 6) NULL,
[IM_MOVI] [numeric] (16, 4) NULL CONSTRAINT [DF__TTCANC_FI__IM_MO__3B6BB5BF] DEFAULT ((0)),
[TI_SITU] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_USUA_CREA] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TTCANC_FI__CO_US__3C5FD9F8] DEFAULT (suser_sname()),
[FE_USUA_CREA] [datetime] NULL CONSTRAINT [DF__TTCANC_FI__FE_US__3D53FE31] DEFAULT (getdate()),
[CO_USUA_MODI] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TTCANC_FI__CO_US__3E48226A] DEFAULT (suser_sname()),
[FE_USUA_MODI] [datetime] NULL CONSTRAINT [DF__TTCANC_FI__FE_US__3F3C46A3] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TTCANC_FINA] ADD CONSTRAINT [PK__TTCANC_F__26D4335E6FEA6AF6] PRIMARY KEY CLUSTERED  ([CO_EMPR], [CO_BANC], [CO_TIPO_FINA], [NU_COMP_CANC], [TI_DOCU_BANC], [NU_DOCU_BANC]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TTCANC_FINA] ADD CONSTRAINT [FK__TTCANC_FI__CO_EM__442BE449] FOREIGN KEY ([CO_EMPR]) REFERENCES [dbo].[TMPARA_TESO] ([CO_EMPR])
GO
